


INSERT INTO OWCMAT.TT_SGM_D2C_SALE_DATA(ID,SALE_CODE,SERIES_ID,SERIES_NAME,NEW_INTENTION_NUM,INTENTION_RETURN_NUM,NEW_ORDER_NUM,DELIVERY_NUM,UNSUBSCRIBE_NUM,RETAINED_ORDER_NUM,REPORT_DATE,REPORT_YEAR,REPORT_WEEK,REPORT_MONTH,CREATE_DATE,CREATE_BY,UPDATE_DATE,UPDATE_BY,REPORT_QUARTER,WECHAT_ADD_NUM,NEW_INVITED_NUM) VALUES (owcmat.sq_sgm_d2c_sale_data.nextval,'CH1018',2267,'探界者Plus（PHEV）',0,0,0,0,0,0,TIMESTAMP '2024-03-28 00:00:00.000000',2024,202413,202403,TIMESTAMP '2024-03-28 21:32:52.000000','task',NULL,NULL,202401,0,0);

select to_date('2024-03-27 00:00:00', 'yyyy-MM-dd hh24:mi:ss') from dual;

INSERT INTO OWCMAT.TT_SGM_D2C_SALE_DATA(ID,SALE_CODE,SERIES_ID,SERIES_NAME,NEW_INTENTION_NUM,INTENTION_RETURN_NUM,NEW_ORDER_NUM,DELIVERY_NUM,UNSUBSCRIBE_NUM,RETAINED_ORDER_NUM,REPORT_DATE,REPORT_YEAR,REPORT_WEEK,REPORT_MONTH,CREATE_DATE,CREATE_BY,UPDATE_DATE,UPDATE_BY,REPORT_QUARTER,WECHAT_ADD_NUM,NEW_INVITED_NUM) VALUES (owcmat.sq_sgm_d2c_sale_data.nextval,'CH1018',2267,'探界者Plus（PHEV）',0,0,0,0,0,0,to_date('2024-03-27 00:00:00','yyyy-MM-dd hh24:mi:ss'),2024,202413,202403,to_date('2024-03-27 00:00:00','yyyy-MM-dd hh24:mi:ss'),'sql',NULL,NULL,202401,0,0);